SELECT t.entity_id
FROM C1_ENTITY_LOG t
WHERE t.id = :id
AND sysdate BETWEEN t.begin_date AND t.end_date